UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMUpNwy3JhFyGRoSfNpGkL0fuXP6unGqaerLwZu97cU='
WHERE
key_id = '336487771880a1fbee5817a0b161ff8e5170b889741bcbd7309eaa26b2b7c2ba'
AND (
token = 'sMUpNwy3JhFyGRoSfNpGkL0fuXP6unGqaerLwZu97cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)