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