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