UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPrlsgC4Xh/lB7rEuHJMuYBfi9dUnekbmfLOhU89TNU='
WHERE
key_id = '31f105a1f0c819ec7f22a11b5241f14717240e5dcfb2271b02feb34863444482'
AND (
token = 'KPrlsgC4Xh/lB7rEuHJMuYBfi9dUnekbmfLOhU89TNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)