UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tcB6ub9SFxBgmhajxEHErZfdFMDWp/8HF6454qo57Nw='
WHERE
key_id = '9a075f29d9e1c1ba99f42ad35e8b7eb958c98ee3b12aa7a48910a98e089ce4dd'
AND (
token = 'tcB6ub9SFxBgmhajxEHErZfdFMDWp/8HF6454qo57Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)