UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DhTYCO6iORAj88L8fzHMjmfB7hJbq4hcUfo4el0T80E='
WHERE
key_id = '231e541d7fa07d1afd83b6a62a07d1570bc5c9f081e265ae13539ef01d1962b3'
AND (
token = 'DhTYCO6iORAj88L8fzHMjmfB7hJbq4hcUfo4el0T80E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)