UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h06UCJu1On29ShTpJDJ6kRz1+p4IMtZs0qk07AqAF4M='
WHERE
key_id = '9d5134719168f7b96c94ed23d67d0e7d7a05fce7efdd9f14302138a0a9ba65cf'
AND (
token = 'h06UCJu1On29ShTpJDJ6kRz1+p4IMtZs0qk07AqAF4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)