UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMp3rBsftvRaRbCuVu6b0BjFyY+NYfG/tuIVAl8VrYA='
WHERE
key_id = '678db11c3dda3d944f6938233152572496ee6628ff167ea265df4011c1c3f42f'
AND (
token = 'BMp3rBsftvRaRbCuVu6b0BjFyY+NYfG/tuIVAl8VrYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)