UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NvGL1iQ0aJKS0fgl5H9GGzwcx9F0PRGeqGRVCG3SHg='
WHERE
key_id = 'e541f1670805c68883281ef1bcee5bb84d4e41fb65870017dc9e5298c1768595'
AND (
token = '8NvGL1iQ0aJKS0fgl5H9GGzwcx9F0PRGeqGRVCG3SHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)