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