UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xh2jKRaRvT+ScUwlEAMBn4n/poFuy2huiHRlGQvWLTY='
WHERE
key_id = '3f6ca675a49106b563c0e7daf9e4015faa3f931ffadd0b889e6e8d8a90aa34ea'
AND (
token = 'Xh2jKRaRvT+ScUwlEAMBn4n/poFuy2huiHRlGQvWLTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)