UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o0oNdD7wbpA58/mSbeBfDY/G90QBtL3T8LuPSJmz10M='
WHERE
key_id = '0579480f024916c51209df231aba77abe0e946564cd97aa29a577dd405664c42'
AND (
token = 'o0oNdD7wbpA58/mSbeBfDY/G90QBtL3T8LuPSJmz10M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)