UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MGv57SKn27yuloVY3DOqQt+nfFsONhNE237g1adBkbc='
WHERE
key_id = '8784e0e05f14489c3e06338a940085141d0bc9d5520ae774518be133ec494c38'
AND (
token = 'MGv57SKn27yuloVY3DOqQt+nfFsONhNE237g1adBkbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)