UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfFIIgN8Ccw7a0aBDaeQu6xjckZVxbgZrJRHgsJgWXA='
WHERE
key_id = '96475b23f602a17b0200fabbe5d384ebc128a05e5339f1f5469ee3342a3eb15c'
AND (
token = 'pfFIIgN8Ccw7a0aBDaeQu6xjckZVxbgZrJRHgsJgWXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)