UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YrlK3x984Eb6xqk2sxDABeQT0mVbJqMWoKLXu2HQkc='
WHERE
key_id = '5c9792811a5ddd7682401e23d21183d0fca2abe0c4e96b229408eb990206322e'
AND (
token = '8YrlK3x984Eb6xqk2sxDABeQT0mVbJqMWoKLXu2HQkc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)