UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NfumIgkHKPcbu2s+4vvklGEGkcGB0v/W9LVW7AgsSg='
WHERE
key_id = 'db4b1d015b3989403b88c35c42f988481807b81d4dbdb4997a3d00ea67b13872'
AND (
token = '5NfumIgkHKPcbu2s+4vvklGEGkcGB0v/W9LVW7AgsSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)