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