UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OE8AQ58UdeuavRt2U2tTX6NNBTizDU+uRk2lsKS6cgg='
WHERE
key_id = 'c10717e4c3611fb08ce8c8b8ecf8a96bec13aac270417f34052271168e1e6b7f'
AND (
token = 'OE8AQ58UdeuavRt2U2tTX6NNBTizDU+uRk2lsKS6cgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)