UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VZFxFOgd9ZzagTsKn5WNAzmCkDNEpFhhNo07F8gWZ74='
WHERE
key_id = 'ac962e8ea591dd734287606d219473ce573891c8303ff59609f5d2fe5a812a66'
AND (
token = 'VZFxFOgd9ZzagTsKn5WNAzmCkDNEpFhhNo07F8gWZ74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)