UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uAbYvVYrQ7syEDPU/49kYepNw7nqN8bIkagDvZ7DsAA='
WHERE
key_id = 'c8ca68f09d4c97e930d5e5efe3d0f79502d69ed5420dd539800cd1ecbee769a8'
AND (
token = 'uAbYvVYrQ7syEDPU/49kYepNw7nqN8bIkagDvZ7DsAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)