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