UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vfmSERicFNu2lgJfZuHbupfsalZeuUmrsAuH0JQAjX4='
WHERE
key_id = '307b1175a59e950ed4ff8f15d744349bdaa96d05c74903251151d1f574e619d6'
AND (
token = 'vfmSERicFNu2lgJfZuHbupfsalZeuUmrsAuH0JQAjX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)