UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hk7v53bP93xgY8MHgydXywy4JSzp67th4mzc/WaxZVQ='
WHERE
key_id = '4129d704b021473c3a34518b0f7cff55fc01d4c427a5011548e1d9cfbffc5785'
AND (
token = 'hk7v53bP93xgY8MHgydXywy4JSzp67th4mzc/WaxZVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)