UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zny3jqtYAF+5RX7q+IByLrikOislyDVObFFL9Nq9aQk='
WHERE
key_id = '1f73868d21d5513658be6931b8ef808fa712bfe4617c2b3b15e7cf2ba196ad4c'
AND (
token = 'Zny3jqtYAF+5RX7q+IByLrikOislyDVObFFL9Nq9aQk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)