UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6teDFspKPMvi4FIhRenlu65h1PsCCHtE95lZSUJld8='
WHERE
key_id = '93bbcc8787b4b486eda02b3e55c7d5f2432315f083a2630f7d034ad07c96a046'
AND (
token = 'C6teDFspKPMvi4FIhRenlu65h1PsCCHtE95lZSUJld8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)