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