UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3wBq99n6v9jJJ3CfxoeAgoIJa2Fg55jJUJUXFRzjIAs='
WHERE
key_id = 'b4867a1fefc9f546e121cd769d1961bb8ac7d47c0f631e4c639f9d3a1dc09d81'
AND (
token = '3wBq99n6v9jJJ3CfxoeAgoIJa2Fg55jJUJUXFRzjIAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)