UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SGiW8SjEIOgsbZDM5LVHuz3G1kqURGvAVcZvOpeadUE='
WHERE
key_id = '20d99a88f3c15d49a44b9bb319d1078615e7229acce11899e3802a2d5161731e'
AND (
token = 'SGiW8SjEIOgsbZDM5LVHuz3G1kqURGvAVcZvOpeadUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)