UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgA2cAdvXPxCWUBCctqCTtfXJWmsL/x5rgqxs19IUg0='
WHERE
key_id = '7a3c3048f617d970e720eec534b2a37d34c49ef9fe62fcac7366ab00b7428036'
AND (
token = 'hgA2cAdvXPxCWUBCctqCTtfXJWmsL/x5rgqxs19IUg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)