UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X911scMSk65qNG80D4ZPUml0urKHdrnTjVxj3Tb01rI='
WHERE
key_id = 'ad0b93a5e47c8e5e06da0b2a0baf227ade9bbcd5aedc72cdffd66554815b0a32'
AND (
token = 'X911scMSk65qNG80D4ZPUml0urKHdrnTjVxj3Tb01rI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)