UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Afoc6c/ccfigijIRNmyP+sxFEOEekGWNuCc3IApWgcs='
WHERE
key_id = 'b41be53f6825f83dcd6e492690c45f5decb9ddb2eec3cd5799c39e0fea75de0b'
AND (
token = 'Afoc6c/ccfigijIRNmyP+sxFEOEekGWNuCc3IApWgcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)