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