UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cftNlSHyhSZ7IWn5yaP588Ls4SDAQ6t5v0Q+WUGctZU='
WHERE
key_id = 'f509ef4c0b413276e215772a30458f7cd98dd031958c73ce24d5f27d42a9be37'
AND (
token = 'cftNlSHyhSZ7IWn5yaP588Ls4SDAQ6t5v0Q+WUGctZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)