UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Xgb2pAUhotyjKp3/0fKQzTYTBbtE0CKrnk65fD/D3s='
WHERE
key_id = '9c8f177c041f91f62ad851cd53933929e77ffd3fd84ae2595ccfc1b534e1892a'
AND (
token = '/Xgb2pAUhotyjKp3/0fKQzTYTBbtE0CKrnk65fD/D3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)