UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vCH3xLofUfyGHgt8z8WkSzIY2TvFpTbiGTVzJASEPJY='
WHERE
key_id = 'f1c1157674270958a9665916c4aa8eae07322e49bdc6e61792269e85e3f07b5f'
AND (
token = 'vCH3xLofUfyGHgt8z8WkSzIY2TvFpTbiGTVzJASEPJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)