UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9TOJssARqnaxF8Qil2mqPtmzhcBMfM64qafem3xHYU='
WHERE
key_id = 'f6e5d670864aa20faf964b2f72aebadd14bd9d8cd445f8a02caceb29f5597327'
AND (
token = 'c9TOJssARqnaxF8Qil2mqPtmzhcBMfM64qafem3xHYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)