UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBavLTdbK8L1+J2LgKUCiSXvTkj/BUH5PnreuYRK4fo='
WHERE
key_id = 'a6cfdf011be7351ef3d3608fd1bff7c38f62e9cb046367ddc98b75348e46e092'
AND (
token = 'gBavLTdbK8L1+J2LgKUCiSXvTkj/BUH5PnreuYRK4fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)