UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8j2Ox1Wjz+D+ODjRZjyEdxBPYFMPKgMW09/wy7Zw1s='
WHERE
key_id = '847280b9914953434a3fcbd2b8b3181d67a7ec2b52a5505bb37f0c6c26ae293f'
AND (
token = 'R8j2Ox1Wjz+D+ODjRZjyEdxBPYFMPKgMW09/wy7Zw1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)