UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1PG2CbAXV46+utpgmQXYvUc5CGNxMGheGAuKd6Or0Y='
WHERE
key_id = 'c94a05e5c55d01b0a9638089eed44cc6e6d7353f596eb8c8a2de45bc1b47792b'
AND (
token = 'V1PG2CbAXV46+utpgmQXYvUc5CGNxMGheGAuKd6Or0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)