UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aB2iOICacr51HCc7JMKGMMWtaln+Qu/SUZQMTuBsYR8='
WHERE
key_id = '27058b67239778577c0ef1551fac1d710d80d833ac3076c9fc019146ab9d9e32'
AND (
token = 'aB2iOICacr51HCc7JMKGMMWtaln+Qu/SUZQMTuBsYR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)