UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K05krz3aU1gxXt8xb31SpEe4PwpTYkM02mCdFIOvQIE='
WHERE
key_id = '266e8378c5a33b637908f542ebf49d4360fc78035202a8f076ff0d9738baf5ba'
AND (
token = 'K05krz3aU1gxXt8xb31SpEe4PwpTYkM02mCdFIOvQIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)