UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tN6lUrj0g5HCc9HChuQ3SEBR3ml+QiS3CeGg+H5M1HE='
WHERE
key_id = '4fcb87787606dae759b020c2030942749a7c33623a7eb7c39e82de1160892dd6'
AND (
token = 'tN6lUrj0g5HCc9HChuQ3SEBR3ml+QiS3CeGg+H5M1HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)