UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cjZMhloigYckd1cPlI5tRMdiDjcEjy4xLyeBV0Am8+k='
WHERE
key_id = '5c641c0e1d0f57c1966f42accf90e7e0c8fb97170b96f8b03bf501209236cd62'
AND (
token = 'cjZMhloigYckd1cPlI5tRMdiDjcEjy4xLyeBV0Am8+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)