UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dBL2+0KzP7XMJkhG44vXfdbC3FikMRKQfxPQ4YHrq1s='
WHERE
key_id = 'd364c0fe770b79d904954fabffd5f3f921609d7e182450938b5784328287541c'
AND (
token = 'dBL2+0KzP7XMJkhG44vXfdbC3FikMRKQfxPQ4YHrq1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)